select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%Palace Court%' or b.enpropertyname like '%Palace Court%') order by updateTime Desc, a.dftpic desc
Very nice with high quality design, brand newly renovated, wall heating, centre ac, full furnished, 3bedrooms with extra storage room, masterbedroom with walkin...
Delicated decoration,the property comprises a brigh and sunny livingroom and well equipped contemporary kitchen, north-south transparent, good ventilation, good...
The apartment is particularly good, Luxury decoration with spacious livingroom and bedrooms,especially good north-south light permeability.whole house floor hea...